from dataBase.DBTools import DBTools

def get_stock_by_date(date):
   sql = "SELECT * FROM ah_yijia WHERE trade_date='"+date+"'"
   return DBTools().search(sql)

if __name__=="__main__":
    result = get_stock_by_date("2000-06-01")
    print(result)